Job Classification
Salaried
Job Type
full-time
Category
Information Technology
Location
ROCKVILLE, MD 20852 US (Primary)
Job Description
LCG is seeking a well-established Database Administrator who has a good blend of technical skills in application design, development, and system integration to support an existing Federal government customer. This is an exciting environment with multiple large projects and upgrades on-going and planned over the next 2 years.
Essential Responsibilities:
All aspects of databases, including administration, data manipulation, security, and performance
Manage and maintain Oracle database servers in all environments
Monitor and tune queries and database performance
Monitor database, disk space, and logs
Design/Implement/Maintain backup/restore strategies per requirements
Provide support for software upgrades and patching
Diagnose and resolve production issues
Work with developers in Agile environment
Create users, control access, and maintain database security
Perform data migration tasks
Operate during normal business hours with some on call/after hours support as needed
Run complex queries to provide data, as requested, for reports
Set standards for database operations, programming, query processes, and security.
Model, design, and construct large relational databases or data warehouses.
Create and optimize data models for warehouse infrastructure and workflow.
Provide Oracle database expertise to support legacy applications
Provide database management support for all ITB initiatives
Ensure databases are designed in a manner that ensures maximum usability and value of the agency’s IT assets.
Collect, Record, and maintain accurate configuration information for all software and database configurations stored in configuration management tool.
Oracle database design, coding, and documentation.
Provide database backup procedures, recovery systems, and SQL.
Assist with schema design, code review, SQL query tuning
Install, tune, implement and upgrade DBMS installations
Write and deploy SQL patches
Altering storage structures to meet the evolving needs of the company.
Setting up database user accounts
Training users on how to access the information in the database.
Finding and debugging malfunctioning programs affecting the database integrity.
Required Qualifications:
Mandatory (Oracle 19c) DBA Certification
Bachelor’s degree in computer science or a related information technology field
8 to 10 years of experience as a Database Admin
Proficient installing, configuring, maintaining and upgrading Oracle and SQL databases
Proficient installing, configuring, maintaining and upgrading Linux based database servers
Shell scripting in Data Base Development
Knowledge of JEE
Experience with monitoring Database capacity and performance
Experience with applying security patches and subsequent testing
Ability to refresh or clone databases from production to development
Experience using stored Procedures, Functions, Triggers and packages
Experience provisioning Microsoft SQL server instances
Experience with Microsoft SQL server clusters
Experience with AppDynamics or other performance monitoring tool
Experience provisioning MySQL instances
Experience interacting with users and customers regularly